create external table jms_dm.dm_end_sender_report_sum_dt 
(
date_time timestamp COMMENT '' ,
 pick_regional_code    string COMMENT '取件_大区code' ,
 pick_regional_name    string COMMENT '取件_大区name' ,
 pick_agent_code       string COMMENT '取件_代理区编码' ,
 pick_agent_name       string COMMENT '取件_代理区名称' ,
 pick_fran_code        string COMMENT '取件_加盟商' ,
 pick_fran_name        string COMMENT '取件_加盟商' ,
 pick_network_code     string COMMENT '取件网点code' ,
 pick_network_name     string COMMENT '取件网点名称' ,
business_name         string COMMENT '品牌' ,
post_site_code        string COMMENT '门店编码' ,
post_site_name        string COMMENT '门店name' ,
post_site_address     string COMMENT '门店地址' ,
customer_code         string COMMENT '客户编号code' ,
customer_name         string COMMENT '客户编号名称' ,
order_source_code              string COMMENT '订单来源code' ,
order_source_name              string COMMENT '订单来源名称' ,
 string COMMENT '' ,
post_site_num         bigint COMMENT '寄件门店数量' ,
customer_num          bigint COMMENT '寄件客户数量' ,
 string COMMENT '' ,
bill_num              bigint COMMENT '订单量' ,
today_pick_num        bigint COMMENT '当日揽收量' ,
nextday_pick_num      bigint COMMENT '次日揽收量' ,
total_pick_num        bigint COMMENT '总揽收量' ,
cancel_num            bigint COMMENT '取消量' ,
pick_time_end_num     bigint COMMENT '超时未取件' ,
type                  string COMMENT '1网点,2门店,3订单维度' ,
 category_id string COMMENT '' ,
 dt string COMMENT '' )
comment 'insert overwrite table jms_dm.dm_end_sender_report_sum_dt partition(dt)'
PARTITIONED BY ( dt string COMMENT '时间分区')
stored as parquet
LOCATION '/dw/hive/jms_dm.db/external/dm_end_sender_report_sum_dt'
TBLPROPERTIES (     'discover.partitions' = 'false',  'parquet.column.index.access' = 'true');
